SELECT * FROM [sr320@washington.edu].[table_CpGMeth_clusters_100_4_v9_90_closest_mRNA.txt]
Left JOIN [sr320@washington.edu].[TJGR_Gene_SPID_evalue_Description]
ON [sr320@washington.edu].[table_CpGMeth_clusters_100_4_v9_90_closest_mRNA.txt].Column13=[sr320@washington.edu].[TJGR_Gene_SPID_evalue_Description].Column1
SELECT * FROM [sr320@washington.edu].[table_CpGMeth_clusters_100_4_v9_90_closest_mRNA.txt]
Left JOIN [sr320@washington.edu].[TJGR_Gene_SPID_evalue_Description]
ON [sr320@washington.edu].[table_CpGMeth_clusters_100_4_v9_90_closest_mRNA.txt].Column13=[sr320@washington.edu].[TJGR_Gene_SPID_evalue_Description].Column1
Where Column15 < 100
SELECT * FROM [sr320@washington.edu].[table_CpGMeth_clusters_100_4_v9_90_closest_mRNA.txt]
Left join [sr320@washington.edu].[TJGR_Gene_SPID_evalue_GO_bigfile]
on [sr320@washington.edu].[table_CpGMeth_clusters_100_4_v9_90_closest_mRNA.txt].Column13=[sr320@washington.edu].[TJGR_Gene_SPID_evalue_GO_bigfile].Column1
Where Column15 < 100